Hệ thống quản lý trường đại học bằng PHP
1 <?php require('../includes/config.php'); ?>
2 <!DOCTYPE HTML>
3 <html>
4 <head>
5 <title>Institut national des sciences appliquées et de technologie</title>
6 <meta charset="utf-8" />
7 <!--[if lte IE 8]><script src="assets/js/ie/html5shiv.js"></script><![endif]-->
8 <!--[if lte IE 9]><link rel="stylesheet" href="assets/css/ie9.css" /><![endif]-->
9 <!--[if lte IE 8]><link rel="stylesheet" href="assets/css/ie8.css" /><![endif]-->
10 <link rel="stylesheet" href="../news/assets/css/main.css" />
11 <meta name="viewport" content="width=device-width, initial-scale=1">
12
13 <!-- Custom CSS -->
14 <link href="../news/assets/css/simple-sidebar.css" rel="stylesheet">
15 <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
16 <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
17 <!--[if lt IE 9]>
18 <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
19 <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
20 <![endif]-->
21 </head>
22 <body title="member">
23 <?php require('../includes/header.php'); ?>
24
25 <div id="wrapper">
26 <!-- Sidebar -->
27 <div id="sidebar-wrapper">
28 <ul class="sidebar-nav">
29 <li class="sidebar-brand">
30 <a href="#">
31 Espace Membre
32 </a>
33 </li>
34 <li>
35 <a href="filiereSelec.php?type=C">Cours</a>
36 </li>
37 <li>
38 <a href="filiereSelec.php?type=AD">Anciens Devoirs</a>
39 </li>
40 <li>
41 <a href="filiereSelec.php?type=E">Exercices</a>
42 </li>
43 <li>
44 <a href="filiereSelec.php?type=R">Résultats</a>
45 </li>
46 </ul>
47 </div>
48 <!-- /#sidebar-wrapper -->
49 <!-- Page Content -->
50 <div id="page-content-wrapper">
51 <div class="container-fluid">
52 <div class="row">
53 <div class="col-lg-12">
54
55
56 <!-- Main -->
57 <div id="main">
58
59 <!-- Post -->
60 <?php
61 try {
62
63 $requested_page = isset($_GET['page']) ? intval($_GET['page']) : 1;
64
65 $reqw = $db->query('SELECT COUNT(*) FROM blog_posts');
66 $script_name = $_SERVER['PHP_SELF'];
67
68 $resp = $reqw->fetch();
69 $article_count=$resp[0];
70 $articles_per_page = 2;
71
72 $page_count = ceil(intval($article_count) / $articles_per_page);
73
74
75 if ( !is_int($requested_page) || $requested_page < 1 || $requested_page > $page_count ) {
76 $requested_page=1;
77 }
78 $first_article_shown = ($requested_page - 1) * $articles_per_page;
79
80 $stmt = $db->query("SELECT * FROM blog_posts ORDER BY postID DESC LIMIT $first_article_shown, $articles_per_page");
81 while($row = $stmt->fetch()){
82 ?>
83 <article class="post">
84 <header>
85 <div class="title">
86 <h2><a href=<?php echo "viewpost.php?id=".$row['postID'] ?>> <?= $row['postTitle'] ?> </a></h2>
87 </div>
88 <div class="meta">
89 <time class="published"><?php echo date('jS M Y H:i:s', strtotime($row['postDate'])) ?></time>
90 </div>
91 </header>
92 <?php
93 if ($row['image'] != "") {
94 echo '<img src="content/'.$row['image'].'" alt="" />';
95 }
96 ?>
97 <p><?php echo $row['postDesc'] ?></p>
98 <footer>
99 <ul class="actions">
100 <li><a href=<?php echo "viewpost.php?id=".$row['postID'] ?> class="button big">Continue Reading</a></li>
101 </ul>
102 <ul class="stats">
103 <li><a href="#">General</a></li>
104 <li><a href="#" class="icon fa-heart">28</a></li>
105 <li><a href="#" class="icon fa-comment">128</a></li>
106 </ul>
107 </footer>
108 </article>
109 <?php
110 }
111
112 } catch(PDOException $e) {
113 echo $e->getMessage();
114 }
115 ?>
116
117
118 <!-- Pagination -->
119 <ul class="actions pagination">
120 <?php
121 if ($requested_page == 1) {
122 echo '<li><a href="#" class="disabled button big previous">Previous Page</a></li>';
123 }
124 else{
125 $new_page=$requested_page - 1;
126 echo '<li><a href="'.$script_name.'?page='.$new_page.'" class=" button big previous">Previous Page</a></li>';
127
128 }
129
130 if ($requested_page == $page_count) {
131 echo '<li><a href="#" class="disabled button big next">Next Page</a></li>';
132 }
133 else{
134 $new_page=$requested_page + 1;
135 echo '<li><a href="'.$script_name.'?page='.$new_page.'" class=" button big next">Next Page</a></li>';
136 }
137
138 ?>
139 </ul>
140
141 </div>
142
143
144
145
146
147 </div>
148 </div>
149 </div>
150 </div>
151 <!-- /#page-content-wrapper -->
152 </div>
153 <!-- /#wrapper -->
154 <!-- jQuery -->
155 <script src="assets/js/jquery.js"></script>
156 <!-- Bootstrap Core JavaScript -->
157 <script src="assets/js/bootstrap.min.js"></script>
158 <!-- Menu Toggle Script -->
159 <!-- Scripts -->
160 <script src="assets/js/jquery.min.js"></script>
161 <script src="assets/js/skel.min.js"></script>
162 <script src="assets/js/util.js"></script>
163 <!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script><![endif]-->
164 <script src="assets/js/main.js"></script>
165 <script src = "https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
166
167 <!-- Include all compiled plugins (below), or include individual files as needed -->
168 <script src = "//maxcdn.bootstrapcdn.com/bootstrap/3.3.1/js/bootstrap.min.js"></script>
169 </body>
170 </html>